UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NyH0Z0iBl7Ie8kmLwjGAkTPNHvBp9QD3JxNhKyKwJGU='
WHERE
key_id = '8bafd8c330da4ca2324077b5c3ee4c5ee53d1eda8cac6cb5f3fa9e60bdf08955'
AND (
token = 'NyH0Z0iBl7Ie8kmLwjGAkTPNHvBp9QD3JxNhKyKwJGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)