UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nn7DM1D0UPaoDVhnAsBI6aNc9i69FDMQHWNtjm83TTw='
WHERE
key_id = '3863b60681656f5bf8bcd3995189fe3196f85f741ca3267d859f198c55715a52'
AND (
token = 'Nn7DM1D0UPaoDVhnAsBI6aNc9i69FDMQHWNtjm83TTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)