UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eKYs9p+yTnvmElly8GJwDoYbzNzQrXaevyiwXec0szA='
WHERE
key_id = '9e1b847bead3b3d7899ab24cc1d22ff5862818c64c7fb88558dea8db4fd5b07b'
AND (
token = 'eKYs9p+yTnvmElly8GJwDoYbzNzQrXaevyiwXec0szA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)