UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxX6d06Klq7IjP0I7g/IwOd7+crosK+WPpgnKnIpjEY='
WHERE
key_id = '04588442b4c3ac49cbbecf007156584171c6626405c36b644c51fc96ca47b4d0'
AND (
token = 'NxX6d06Klq7IjP0I7g/IwOd7+crosK+WPpgnKnIpjEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)