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