UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfDaB1uSxLRAwuLw9RqmPIy8xqDttFEDQtKrs4aXlh8='
WHERE
key_id = 'd1cca409e5b5feba8454b5f5a0aee439a145a55677745a44751a2c46255b2fcd'
AND (
token = 'lfDaB1uSxLRAwuLw9RqmPIy8xqDttFEDQtKrs4aXlh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)