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