UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQhe8DgIXndLZNo3skZHgZKB5RLSHlOAhD1/aMJ7foo='
WHERE
key_id = '1b5ed4a4aa9e906721462e13f8c6d703a7165b9cc8586e3efe1c56e1ed8e1940'
AND (
token = 'tQhe8DgIXndLZNo3skZHgZKB5RLSHlOAhD1/aMJ7foo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)