UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'my0RYXmoqMwYw9eJHxi4YRbdRg9skUz52qp7nsdm34M='
WHERE
key_id = '3a34c1644af49cf886499e332bc6c161f5bdfab41df437021ebfe69afda7b5ab'
AND (
token = 'my0RYXmoqMwYw9eJHxi4YRbdRg9skUz52qp7nsdm34M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)