UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBO7iWRkG+ouClqSUdCl53DmWBhQQkrFGYK4Jm+6S00='
WHERE
key_id = 'e5f29228b436dbb00bf95e95b7a9b9407794d044a3751c5a497aaa2a2e723846'
AND (
token = 'KBO7iWRkG+ouClqSUdCl53DmWBhQQkrFGYK4Jm+6S00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)