UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mKDYZ5xtstgESJLQboW4IOedQhFJlR3TVbLppZ1zh7k='
WHERE
key_id = '96149486e16f283fd884994396191b0373118af6586a4b1ceaacda779e4fc44d'
AND (
token = 'mKDYZ5xtstgESJLQboW4IOedQhFJlR3TVbLppZ1zh7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)