UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UbEgc2aOIsfKVz4cyi7hWzbr3XfwuCdlI+iW/83JjyQ='
WHERE
key_id = '99ae8b4e4307aa0d5946767b971a07f9e61f4701883f0b5fb05eb19b979fec99'
AND (
token = 'UbEgc2aOIsfKVz4cyi7hWzbr3XfwuCdlI+iW/83JjyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)