UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bL7F3cVsEqNtK1z3RixO5U4DHyaE+xlFjyHxVnz0A0o='
WHERE
key_id = '7fbdabc8956e7668ccb8cd99ab01fa778f1e7fa1e12aa43934e060e733615fc1'
AND (
token = 'bL7F3cVsEqNtK1z3RixO5U4DHyaE+xlFjyHxVnz0A0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)