UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oF0qozoJhZ4zWkIOi53vzJlvNQSNPCOpYSNJQSNoD80='
WHERE
key_id = '1f1e94acacba22a02fbe21e0b1264bdb4efed3a2e219ae96dccafeca134abc81'
AND (
token = 'oF0qozoJhZ4zWkIOi53vzJlvNQSNPCOpYSNJQSNoD80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)