UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tliZdQHIMStVIMYM0iAYvrcStCdQ2EqTCFaRQ/TGIbI='
WHERE
key_id = 'b38ea2f6d6224bd6e16413bfc77bbe947eb8c4b20b425f3d288012df4df92f2c'
AND (
token = 'tliZdQHIMStVIMYM0iAYvrcStCdQ2EqTCFaRQ/TGIbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)