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