UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1dm2NxegJ/ksh6fAq/L/UYOfvgoun2kwfIkcTr/1Qu4='
WHERE
key_id = '54f16088085ac18fb2169df1236fabd478a564581fed7fe94d77a0f266323f10'
AND (
token = '1dm2NxegJ/ksh6fAq/L/UYOfvgoun2kwfIkcTr/1Qu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)