UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qb0xHw670ppMoab+HlKWB0Xe3mpYZQh7t83U1IyNMXU='
WHERE
key_id = '84abfca0e96991986d1db98fc2f3880598d0d4fa94a5b591e5af5351f7695180'
AND (
token = 'qb0xHw670ppMoab+HlKWB0Xe3mpYZQh7t83U1IyNMXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)