UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wfXWS4PJZxvdeV2CHpzce8E2SRbdQqbWw2V1GdVtcX4='
WHERE
key_id = '65b812e821e4cd83c7c92da5a9a08cabb8b097cdde2d4772ceb5ba7d331d6cf5'
AND (
token = 'wfXWS4PJZxvdeV2CHpzce8E2SRbdQqbWw2V1GdVtcX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)