UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oULPjTCTZLyKKBPc4dsSwK5TLLq4ygqFIpGeF1cIxSs='
WHERE
key_id = '1c27d08154ad9d12372e6cfd54c80c7005eaa1eab250776e8c73acef852a97c1'
AND (
token = 'oULPjTCTZLyKKBPc4dsSwK5TLLq4ygqFIpGeF1cIxSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)