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