UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEDetg1enxKQDdtzanMC1ma7+9TLqNndFxbeZPavn0o='
WHERE
key_id = 'a8a45bd83ef40ca2a33f9929376bec12f0319bd4454d83e2c01b44e1b54d6a20'
AND (
token = 'ZEDetg1enxKQDdtzanMC1ma7+9TLqNndFxbeZPavn0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)