UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmO72/+36kPHzfZ8DqF+A6ALqEti6OcfW1ktGZXbFus='
WHERE
key_id = '8d713fbde1cce2555b1fb2faf93b5fc170a13e7273fa2b5eb1d08a1e27f0c32c'
AND (
token = 'ZmO72/+36kPHzfZ8DqF+A6ALqEti6OcfW1ktGZXbFus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)