UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3LU2nJjvmhJGz52RN5yljnTqwJus1VMUJc7kBwlOKA='
WHERE
key_id = '3670f82f87c6507a15478c5c4144e77c56ffc9f975f0a8a1e0f7dc21323efa72'
AND (
token = 'J3LU2nJjvmhJGz52RN5yljnTqwJus1VMUJc7kBwlOKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)