UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPQgVa5aDOtt/qe3jqoQj/0JirWXNz6ZO7+WpBIAWNU='
WHERE
key_id = 'a5fd7f9153b4c30cec4fe34f186d5b567e1802ec3a9f0dca7854d42122fdf6af'
AND (
token = 'aPQgVa5aDOtt/qe3jqoQj/0JirWXNz6ZO7+WpBIAWNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)