UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tR5U7Tt/HuxCaPam+jsRVJ3AU6SrCFDaVKgGcfNHLpA='
WHERE
key_id = '27168159ae03a2ca3148f75c59c132b9c5ef49ad6e6be86ab8456d8e9d68973e'
AND (
token = 'tR5U7Tt/HuxCaPam+jsRVJ3AU6SrCFDaVKgGcfNHLpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)