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