UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XP/fczIEpUOCESsWZfTB0odHJbLzP6eWB2Ve2ewi8oA='
WHERE
key_id = 'd75fe199fe6b374ee76c447820c893446a6d35d7e25ab85ac75d787cf92d9347'
AND (
token = 'XP/fczIEpUOCESsWZfTB0odHJbLzP6eWB2Ve2ewi8oA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)