UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '390oZ1GvOPD9FbEljuI63BQJUA4eZttn5JaZAvGGTsc='
WHERE
key_id = 'ef38340a9964bebdd8b4e6ff3ec40c69c89f04bc4b9d45af1b3da5942eaa8506'
AND (
token = '390oZ1GvOPD9FbEljuI63BQJUA4eZttn5JaZAvGGTsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)